Problem Note 53751: A "Cannot connect to the database ..." error is displayed during the SAS® Social Network Analysis Test Connection configuration step
If SAS Social Network Analysis is packaged with SAS® Enterprise GRC, then a configuration error is displayed when you select Test Connection. The error is displayed even though you specified the correct parameters in the Test Connection pane.
Cannot connect to the database. Please verify that the database hostname, DB
name, and credentials are correct.
The problem occurs because there is a property file missing from the SAS Software Depot that was created from the order. A hot fix is available to create the missing file. After the hot fix is applied as part of the installation, you can copy the file SASHome/SASSocialNetworkAnalysis/6.2/Config/snamid_default.properties to your depot in one of these locations:
If you do not apply the hot fix before the configuration, then you are not able to move past the Database Test Connection pane. In that case, you need to cancel out of the configuration, and apply the hot fix so that you can copy the snamid_default.properties file to your depot. Because the configuration did not complete, you should be able to restart the configuration after copying the file. The configuration should finish.
Operating System and Release Information
SAS System | SAS Social Network Analysis Server | Solaris for x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Linux for x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
HP-UX IPF | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
64-bit Enabled Solaris | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
64-bit Enabled AIX | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Windows 7 Ultimate x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Windows 7 Ultimate 32 bit | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Windows 7 Professional x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Windows 7 Professional 32 bit | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Windows 7 Home Premium x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Windows 7 Home Premium 32 bit | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Windows 7 Enterprise x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Windows 7 Enterprise 32 bit | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows Server 2012 Std | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows Server 2012 R2 Std | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows Server 2012 R2 Datacenter | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows Server 2008 for x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows Server 2008 R2 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows Server 2008 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows 8.1 Pro 32-bit | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows 8.1 Pro | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows 8.1 Enterprise x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows 8.1 Enterprise 32-bit | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows 8 Pro x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows 8 Pro 32-bit | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows 8 Enterprise x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows Server 2012 Datacenter | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft Windows 8 Enterprise 32-bit | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
Microsoft® Windows® for x64 | 6.2 | 6.2_M1 | 9.4 TS1M1 | 9.4 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2015-06-05 08:36:23 |
Date Created: | 2014-07-25 09:03:13 |